/**   
 * @Title: BillingUserOverviewDao
 * @Package com.isoftstone.industry.aaa.core.dao.assist
 * @Description: TODO
 * @Author Alvin
 * @Date Jun 26, 2014 11:24:15 AM
 * @version V1.0
 */
package com.isoftstone.industry.aaa.core.dao.assist;

import org.springframework.data.jpa.repository.Query;

import com.isoftstone.industry.persistance.bean.BillingUserOverview;
import com.isoftstone.modules.core.persistence.IGenericDao;

/**
 * @ClassName: BillingUserOverviewDao
 * @Description: TODO
 * @Author Alvin
 * @Date Jun 26, 2014 11:24:15 AM
 */
public interface BillingUserOverviewDao extends IGenericDao<BillingUserOverview, String> {
	
	@Query("select x from BillingUserOverview x where x.appInstance.id = ?1 and x.isHistroy = '0'")
	public BillingUserOverview getBillingUserOverviewByAppInstId(String appInstId);
	
	@Query("select x from BillingUserOverview x where x.productInstance.id = ?1 and x.isHistroy = '0'")
	public BillingUserOverview getBillingUserOverviewByAppProdId(String prodInstId);
	
	
}
